https://gibs.com RSS feeds for Global Internet Business Solutions ~ GIBS 60 https://gibs.com/Support/Knowledge-Base/ID/340/How_to_check_net_runtime_version_in_Azure_App_Service#Comments 0 https://gibs.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=51&ModuleID=411&ArticleID=340 https://gibs.com:443/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=340&PortalID=0&TabID=51 https://gibs.com/Support/Knowledge-Base/ID/340/How_to_check_net_runtime_version_in_Azure_App_Service Using the Azure Portal Sign in to the Azure portal. Navigate to your App Service and select it. In the left navigation menu, under Settings, select Configuration. Select the General settings tab. In the Stack settings section, you will see the Runtime stack and the specific .NET version being used.  Using the Kudu Console (Advanced Tools) The Kudu console provides direct access to the underlying environment and installed runtimes.  In the Azure portal, navigate to your App Service. Under Development Tools, select Advanced Tools, then select Go. In the Kudu services window, select Debug console and choose either CMD or PowerShell. Run the appropriate command in the console: For .NET Core and .NET 5+, run dotnet --list-runtimes or dotnet --info to see all installed versions. Webmaster Wed, 17 Dec 2025 16:56:00 GMT f1397696-738c-4295-afcd-943feb885714:340 https://gibs.com/Support/Knowledge-Base/ID/326/Estimated_demand_for_QR_Code_use_in_2025_and_the_future#Comments 0 https://gibs.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=51&ModuleID=411&ArticleID=326 https://gibs.com:443/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=326&PortalID=0&TabID=51 https://gibs.com/Support/Knowledge-Base/ID/326/Estimated_demand_for_QR_Code_use_in_2025_and_the_future It's estimated that by 2025, over 100 million smartphone users in the US will be scanning QR codes. This indicates a strong and growing demand for QR code use. This growth is driven by several factors: Increased smartphone adoption: As more people own smartphones, the potential user base for QR codes expands. Integration with mobile payments: QR codes are increasingly used for mobile payments, particularly in developing regions, driving their adoption. Juniper Research predicts that global spending using QR code payments will reach over $3 trillion by 2025. Versatility and convenience: QR codes offer a convenient way to access information, make payments, check in for events, and more. This versatility contributes to their widespread use across various industries. Omnichannel experiences: Businesses are increasingly using QR codes to connect online and offline experiences, creating seamless omnichannel journeys for customers. Overall, the demand for QR code use is expected to remain strong in 2025 and beyond, driven by technological advancements, increasing smartphone penetration, and the growing need for convenient and versatile solutions in various sectors. Sample our QR Code Maker DNN app. Webmaster Tue, 07 Jan 2025 16:37:00 GMT f1397696-738c-4295-afcd-943feb885714:326 https://gibs.com/Support/Knowledge-Base/ID/4/Azure_SQL_uses_Greenwich_Mean_Time#Comments 0 https://gibs.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=51&ModuleID=411&ArticleID=4 https://gibs.com:443/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=4&PortalID=0&TabID=51 https://gibs.com/Support/Knowledge-Base/ID/4/Azure_SQL_uses_Greenwich_Mean_Time // AZURE SQL USES GREENWICH MEAN TIME . . . Azure SQL Database does not support time zone settings; it always follows UTC. Use AT TIME ZONE in SQL Database if you need to interpret date and time information in a non-UTC time zone. Declare @current_utc_offset int IF  ServerProperty('EngineEdition') >= 5 Begin set @current_utc_offset = (select  convert(int, left(current_utc_offset,3)) AS current_utc_offset from sys.time_zone_info Where Name = 'US Eastern Standard Time') End   Then I use this information to adjust the query data   SELECT  dateadd(hour, @current_utc_offset, dateadd(hour, datediff(hour, 0, [CreatedOnDate]), 0)) as TimeStampHour   Complete Query Used for report:   IF  ServerProperty('EngineEdition') >= 5 Begin set @current_utc_offset = (select  convert(int, left(current_utc_offset,3)) AS current_utc_offset from sys.time_zone_info Where Name = 'US Eastern Standard Time') End     if(@ServiceLocation='0' or @ServiceLocation is null) begin        set @ServiceLocation=null; end   SELECT  dateadd(hour, @current_utc_offset, dateadd(hour, datediff(hour, 0, [CreatedOnDate]), 0)) as TimeStampHour , Count(*) AS ClientsServed FROM  [GIBS_FBClientsVisits] where   ( [CreatedOnDate]     BETWEEN @StartDate      and @EndDate)     and  (@ServiceLocation is null or GIBS_FBClientsVisits.ServiceLocation=@ServiceLocation) GROUP BY dateadd(hour, datediff(hour, 0, [CreatedOnDate]), 0) ORDER BY dateadd(hour, datediff(hour, 0, [CreatedOnDate]), 0)   Thu, 23 May 2024 17:59:00 GMT f1397696-738c-4295-afcd-943feb885714:4 https://gibs.com/Support/Knowledge-Base/ID/13/Getting_Eastern_Standard_Time_from_Azure_SQL#Comments 0 https://gibs.com/DesktopModules/DnnForge%20-%20NewsArticles/RssComments.aspx?TabID=51&ModuleID=411&ArticleID=13 https://gibs.com:443/DesktopModules/DnnForge%20-%20NewsArticles/Tracking/Trackback.aspx?ArticleID=13&PortalID=0&TabID=51 https://gibs.com/Support/Knowledge-Base/ID/13/Getting_Eastern_Standard_Time_from_Azure_SQL Declare @todays_date Date set @todays_date = CAST(SYSDATETIMEOFFSET() AT TIME ZONE 'Eastern Standard Time' AS date) For example, if you want the current date and time as a datetime value like GETDATE() does, do this: CAST(SYSDATETIMEOFFSET() AT TIME ZONE 'Eastern Standard Time' AS datetime) If you want the current date and time as a datetime2 value like SYSDATETIME() does, do this: CAST(SYSDATETIMEOFFSET() AT TIME ZONE 'Eastern Standard Time' AS datetime2) And if you just want the current date, you can do this: CAST(SYSDATETIMEOFFSET() AT TIME ZONE 'Eastern Standard Time' AS date) Tue, 03 Nov 2020 16:20:00 GMT f1397696-738c-4295-afcd-943feb885714:13